package com.example.superoa.model.mappers;

import java.math.BigDecimal;
import java.util.Date;
import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.example.superoa.model.pojos.KqOverwork;

@Mapper
public interface OvertimeMapper {
	public JSONArray overtimeSelectAll();
	
	public JSONObject selectOvertimeId(int id);
	
	public Double selectOvertimeTime(int id,int oclass,int year,int month);
	
	public BigDecimal selectOvertim(int year,int month,int staff_id,int type);

	public Integer selectOverid();
	//判断date那天加的什么类型的班,返回加班类型与加班id
	public JSONObject selectbetween(int id,Date date);
	
	public JSONArray selectOvertimeStaff(int staff_id);
	
	public JSONArray selectOvertimeStaff1(int staff_id);
	
	//通过员工id查询,员工未审核的加班申请
	public JSONArray selectOvertimeID(Integer id);
	
	//通过员工id查询,员工的申请
	public JSONArray selectOvertimeIDD(Integer id);
	
	//通过申请id查找申请
	public JSONArray selectOvertimeid(Integer id);
	//通过员工id查询老师未审核的申请
	public JSONArray selectteach(Integer staff_id);
	//通过员工id查询老师申请
	public JSONArray selectstaffapply(Integer staff_id);
	//通过申请id查询详情（申请和审批）
	public JSONArray applyxiangqing(Integer apply_id);
	//通过审核id查询申请
	public JSONArray findpxapp(Integer pxapproval_id);
	//查询申请人
	public JSONArray findteastaff(Integer staff_id);
	//删除讲师
	public void deletetea(Integer teacher_id);
	//通过申请id查找审核id
	public JSONArray findapplyid(Integer apply_id);
	//审核人
	public JSONArray findsubsh(Integer shr_id);
	//申请人
	public JSONArray findsqr(Integer staff_id);
	//详情
	public JSONArray subxiangqing(Integer sub_id);
	//通过员工id查询老师未审核的申请
	public JSONArray selectteach1(Integer staff_id);
	//通过员工id查询老师申请
	public JSONArray selectstaffapply1(Integer staff_id);
	//通过申请id查询详情（申请和审批）
	public JSONArray applyxiangqing1(Integer apply_id);	
	//招聘待审批
	public JSONArray rapplyfsp(Integer staff_id);
	//招聘申请
	public JSONArray rapplysq(Integer staff_id);
	//招聘详情
	public JSONArray rapplyxq(Integer rapplyid);
}
